﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Estatisticas" targetNamespace="http://tempuri.org/Estatisticas.xsd" xmlns:mstns="http://tempuri.org/Estatisticas.xsd" xmlns="http://tempuri.org/Estatisticas.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="miraparkConnectionStringDataSets" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="miraparkConnectionStringDataSets (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MakeIT.MiraPark.Apresentacao.Properties.Settings.GlobalReference.Default.miraparkConnectionStringDataSets" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mensalistaMovimentoTableAdapter" GeneratorDataComponentClassName="mensalistaMovimentoTableAdapter" Name="mensalistaMovimento" UserDataComponentName="mensalistaMovimentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.movimentacao" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Entrada, Saida, Especie, Placa, Valor
FROM            movimentacao
WHERE        (IdMensalista = @idMensalista) AND (Entrada &gt;= @dtIni) AND (Entrada &lt;= @dtFin)
ORDER BY Entrada</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="idMensalista" ColumnName="IdMensalista" DataSourceName="mirapark.movimentacao" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idMensalista" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdMensalista" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="dtIni" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="dtFin" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtFin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Entrada" DataSetColumn="Entrada" />
              <Mapping SourceColumn="Saida" DataSetColumn="Saida" />
              <Mapping SourceColumn="Especie" DataSetColumn="Especie" />
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mensalistaVeiculoTableAdapter" GeneratorDataComponentClassName="mensalistaVeiculoTableAdapter" Name="mensalistaVeiculo" UserDataComponentName="mensalistaVeiculoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        mensalistaxveiculo.Placa, cor.Nome, marca.Marca, modelo.Modelo, tipoveiculo.TipoVeiculo, porteveiculo.PorteVeiculo
FROM            cor INNER JOIN
                         veiculo ON cor.IdCor = veiculo.IdCor INNER JOIN
                         marca ON veiculo.IdMarca = marca.IdMarca INNER JOIN
                         modelo ON veiculo.IdModelo = modelo.IdModelo INNER JOIN
                         porteveiculo ON veiculo.IdPorte = porteveiculo.IdPorteVeiculo INNER JOIN
                         tipoveiculo ON veiculo.IdTipo = tipoveiculo.IdTipoVeiculo RIGHT OUTER JOIN
                         mensalistaxveiculo ON veiculo.Placa = mensalistaxveiculo.Placa
WHERE        (mensalistaxveiculo.IdMensalista = @idMensalista)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="idMensalista" ColumnName="IdMensalista" DataSourceName="mirapark.mensalistaxveiculo" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idMensalista" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdMensalista" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Marca" DataSetColumn="Marca" />
              <Mapping SourceColumn="Modelo" DataSetColumn="Modelo" />
              <Mapping SourceColumn="TipoVeiculo" DataSetColumn="TipoVeiculo" />
              <Mapping SourceColumn="PorteVeiculo" DataSetColumn="PorteVeiculo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mensalistaFranquiaTableAdapter" GeneratorDataComponentClassName="mensalistaFranquiaTableAdapter" Name="mensalistaFranquia" UserDataComponentName="mensalistaFranquiaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.mensalistaxfranquia" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DataIni, DataFim
FROM            mensalistaxfranquia
WHERE        (IdMensalista = @idMensalista) AND (DataFim &gt;= @datIni) AND (DataIni &lt;= @datFim)
ORDER BY DataIni
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="idMensalista" ColumnName="IdMensalista" DataSourceName="mirapark.mensalistaxfranquia" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idMensalista" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdMensalista" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datIni" ColumnName="DataFim" DataSourceName="mirapark.mensalistaxfranquia" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@datIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataFim" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datFim" ColumnName="DataIni" DataSourceName="mirapark.mensalistaxfranquia" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@datFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataIni" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DataIni" DataSetColumn="DataIni" />
              <Mapping SourceColumn="DataFim" DataSetColumn="DataFim" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mensalistaPagamentoTableAdapter" GeneratorDataComponentClassName="mensalistaPagamentoTableAdapter" Name="mensalistaPagamento" UserDataComponentName="mensalistaPagamentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recebimento.Recebimento, recebimento.DtVencimento, recebimento.DtPagamento, formapagamento.FormaPagamento, recebimento.Valor, 
                         recebimento.ValorRec
FROM            recebimento LEFT OUTER JOIN
                         formapagamento ON recebimento.IdFormaPagamento = formapagamento.IdFormaPagamento
WHERE        (recebimento.IdMensalista = @idMensalista) AND (recebimento.DtPagamento &gt;= @datIni) AND (recebimento.DtPagamento &lt;= @datFim)
ORDER BY recebimento.DtVencimento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="idMensalista" ColumnName="IdMensalista" DataSourceName="mirapark.recebimento" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idMensalista" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdMensalista" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datIni" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@datIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datFim" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@datFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Recebimento" DataSetColumn="Recebimento" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="DtPagamento" DataSetColumn="DtPagamento" />
              <Mapping SourceColumn="FormaPagamento" DataSetColumn="FormaPagamento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="ValorRec" DataSetColumn="ValorRec" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mensalistaPagementoAbertoTableAdapter" GeneratorDataComponentClassName="mensalistaPagementoAbertoTableAdapter" Name="mensalistaPagementoAberto" UserDataComponentName="mensalistaPagementoAbertoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.recebimento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Recebimento, DtVencimento, Valor
FROM            recebimento
WHERE        (IdMensalista = @idMensalista) AND (DtVencimento &gt;= @datIni) AND (DtVencimento &lt;= @datFim) AND (DtPagamento IS NULL)
ORDER BY DtVencimento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="idMensalista" ColumnName="IdMensalista" DataSourceName="mirapark.recebimento" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idMensalista" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdMensalista" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datIni" ColumnName="DtVencimento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@datIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtVencimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datFim" ColumnName="DtVencimento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@datFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtVencimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Recebimento" DataSetColumn="Recebimento" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mensalistaTableAdapter" GeneratorDataComponentClassName="mensalistaTableAdapter" Name="mensalista" UserDataComponentName="mensalistaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cliente.Nome, cliente.Endereco, cliente.EnderecoNumero, cliente.Complemento, cliente.Bairro, cliente.Cidade, cliente.UF, cliente.Email, cliente.Telefone1, 
                         cliente.Telefone2, cliente.Telefone3, cliente.Contato, cliente.Responsavel, cliente.Ativo, cliente.CPF, cliente.CNPJ, cliente.IE, cliente.IM, cliente.Pais, 
                         cliente.SMS, cliente.IdCliente, mensalista.QtdVagas, mensalista.Ativo AS Expr1, tabelamensal.Valor, tabelamensal.TabelaMensal
FROM            mensalista INNER JOIN
                         tabelamensal ON mensalista.IdTabelaMensal = tabelamensal.IdTabelaMensal INNER JOIN
                         cliente ON mensalista.IdCliente = cliente.IdCliente
WHERE        (mensalista.IdMensalista = @idMensalista)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="idMensalista" ColumnName="IdMensalista" DataSourceName="mirapark.mensalista" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idMensalista" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdMensalista" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Endereco" DataSetColumn="Endereco" />
              <Mapping SourceColumn="EnderecoNumero" DataSetColumn="EnderecoNumero" />
              <Mapping SourceColumn="Complemento" DataSetColumn="Complemento" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="UF" DataSetColumn="UF" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Telefone1" DataSetColumn="Telefone1" />
              <Mapping SourceColumn="Telefone2" DataSetColumn="Telefone2" />
              <Mapping SourceColumn="Telefone3" DataSetColumn="Telefone3" />
              <Mapping SourceColumn="Contato" DataSetColumn="Contato" />
              <Mapping SourceColumn="Responsavel" DataSetColumn="Responsavel" />
              <Mapping SourceColumn="Ativo" DataSetColumn="Ativo" />
              <Mapping SourceColumn="CPF" DataSetColumn="CPF" />
              <Mapping SourceColumn="CNPJ" DataSetColumn="CNPJ" />
              <Mapping SourceColumn="IE" DataSetColumn="IE" />
              <Mapping SourceColumn="IM" DataSetColumn="IM" />
              <Mapping SourceColumn="Pais" DataSetColumn="Pais" />
              <Mapping SourceColumn="SMS" DataSetColumn="SMS" />
              <Mapping SourceColumn="IdCliente" DataSetColumn="IdCliente" />
              <Mapping SourceColumn="QtdVagas" DataSetColumn="QtdVagas" />
              <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="TabelaMensal" DataSetColumn="TabelaMensal" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="placaMovimentacaoTableAdapter" GeneratorDataComponentClassName="placaMovimentacaoTableAdapter" Name="placaMovimentacao" UserDataComponentName="placaMovimentacaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.movimentacao" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Placa, Entrada, Saida, Valor, Especie
FROM            movimentacao
WHERE        (Placa = @placa) AND (Entrada &gt;= @datIni) AND (Entrada &lt;= @datFim)
ORDER BY Entrada</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="placa" ColumnName="Placa" DataSourceName="mirapark.movimentacao" DataTypeServer="varchar(10)(10)" DbType="String" Direction="Input" ParameterName="@placa" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Placa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datIni" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@datIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datFim" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@datFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Entrada" DataSetColumn="Entrada" />
              <Mapping SourceColumn="Saida" DataSetColumn="Saida" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="Especie" DataSetColumn="Especie" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="placaVeiculoTableAdapter" GeneratorDataComponentClassName="placaVeiculoTableAdapter" Name="placaVeiculo" UserDataComponentName="placaVeiculoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        veiculo.Placa, cor.Nome, marca.Marca, modelo.Modelo, porteveiculo.PorteVeiculo, tipoveiculo.TipoVeiculo
FROM            veiculo LEFT OUTER JOIN
                         porteveiculo ON veiculo.IdPorte = porteveiculo.IdPorteVeiculo LEFT OUTER JOIN
                         tipoveiculo ON veiculo.IdTipo = tipoveiculo.IdTipoVeiculo LEFT OUTER JOIN
                         modelo ON veiculo.IdModelo = modelo.IdModelo LEFT OUTER JOIN
                         marca ON veiculo.IdMarca = marca.IdMarca LEFT OUTER JOIN
                         cor ON veiculo.IdCor = cor.IdCor
WHERE        (veiculo.Placa = @placa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="placa" ColumnName="Placa" DataSourceName="mirapark.veiculo" DataTypeServer="varchar(10)(10)" DbType="String" Direction="Input" ParameterName="@placa" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Placa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Marca" DataSetColumn="Marca" />
              <Mapping SourceColumn="Modelo" DataSetColumn="Modelo" />
              <Mapping SourceColumn="PorteVeiculo" DataSetColumn="PorteVeiculo" />
              <Mapping SourceColumn="TipoVeiculo" DataSetColumn="TipoVeiculo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="eMensalTableAdapter" GeneratorDataComponentClassName="eMensalTableAdapter" Name="eMensal" UserDataComponentName="eMensalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.movimentacao" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Especie,  COUNT(Especie) AS quantidade, SUM(Valor) AS valor
FROM            movimentacao
WHERE        (Especie IN ('Avulso', 'Convenio', 'Mensal', 'Mensalidade')) AND (Entrada &gt;= @datIni) AND (Entrada &lt;= @datFim)
GROUP BY Especie</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="datIni" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@datIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datFim" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@datFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="valor" DataSetColumn="valor" />
              <Mapping SourceColumn="Especie" DataSetColumn="Especie" />
              <Mapping SourceColumn="quantidade" DataSetColumn="quantidade" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="eMensalAnaliticoTableAdapter" GeneratorDataComponentClassName="eMensalAnaliticoTableAdapter" Name="eMensalAnalitico" UserDataComponentName="eMensalAnaliticoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.movimentacao" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        date_format(Entrada, '%d/%m/%Y') AS Dia, Especie,  COUNT(Especie) AS quantidade, SUM(Valor) AS valor
FROM            movimentacao
WHERE        (Especie IN ('Avulso', 'Convenio', 'Mensal', 'Mensalidade')) AND (Entrada &gt;= @datIni) AND (Entrada &lt;= @datFim)
GROUP BY Dia, Especie</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="datIni" ColumnName="Entrada" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@datIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="datFim" ColumnName="Entrada" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@datFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="valor" DataSetColumn="valor" />
              <Mapping SourceColumn="Especie" DataSetColumn="Especie" />
              <Mapping SourceColumn="quantidade" DataSetColumn="quantidade" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="eDiaTableAdapter" GeneratorDataComponentClassName="eDiaTableAdapter" Name="eDia" UserDataComponentName="eDiaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        date_format(Entrada, '%d/%m/%Y') AS Dia, COUNT(Especie) AS Qtd, SUM(Valor) AS Valor
FROM            movimentacao
WHERE        (Especie IN ('Avulso', 'Convenio', 'Diaria Especial', 'Mensal', 'Mensalidade')) AND (Entrada &gt;= @DatIni) AND (Entrada &lt;= @DatFim)
GROUP BY Dia</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="Qtd" DataSetColumn="Qtd" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="eMesTableAdapter" GeneratorDataComponentClassName="eMesTableAdapter" Name="eMes" UserDataComponentName="eMesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        date_format(Entrada, '%m/%Y') AS Mes, COUNT(Especie) AS Qtd, SUM(Valor) AS Valor
FROM            movimentacao
WHERE        (Especie IN ('Avulso', 'Convenio', 'Diaria Especial', 'Mensal', 'Mensalidade')) AND (Entrada &gt;= @DatIni) AND (Entrada &lt;= @DatFim)
GROUP BY Mes</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="Entrada" DataSourceName="mirapark.movimentacao" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Entrada" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Qtd" DataSetColumn="Qtd" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Estatisticas" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Estatisticas" msprop:Generator_UserDSName="Estatisticas">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="mensalistaMovimento" msprop:Generator_UserTableName="mensalistaMovimento" msprop:Generator_RowEvArgName="mensalistaMovimentoRowChangeEvent" msprop:Generator_TableVarName="tablemensalistaMovimento" msprop:Generator_TablePropName="mensalistaMovimento" msprop:Generator_RowDeletingName="mensalistaMovimentoRowDeleting" msprop:Generator_RowChangingName="mensalistaMovimentoRowChanging" msprop:Generator_RowDeletedName="mensalistaMovimentoRowDeleted" msprop:Generator_TableClassName="mensalistaMovimentoDataTable" msprop:Generator_RowChangedName="mensalistaMovimentoRowChanged" msprop:Generator_RowEvHandlerName="mensalistaMovimentoRowChangeEventHandler" msprop:Generator_RowClassName="mensalistaMovimentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Entrada" msprop:Generator_ColumnVarNameInTable="columnEntrada" msprop:Generator_ColumnPropNameInRow="Entrada" msprop:Generator_ColumnPropNameInTable="EntradaColumn" msprop:Generator_UserColumnName="Entrada" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Saida" msprop:Generator_ColumnVarNameInTable="columnSaida" msprop:Generator_ColumnPropNameInRow="Saida" msprop:Generator_ColumnPropNameInTable="SaidaColumn" msprop:Generator_UserColumnName="Saida" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Especie" msprop:Generator_ColumnVarNameInTable="columnEspecie" msprop:Generator_ColumnPropNameInRow="Especie" msprop:Generator_ColumnPropNameInTable="EspecieColumn" msprop:Generator_UserColumnName="Especie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnPropNameInTable="PlacaColumn" msprop:Generator_UserColumnName="Placa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="mensalistaVeiculo" msprop:Generator_UserTableName="mensalistaVeiculo" msprop:Generator_RowEvArgName="mensalistaVeiculoRowChangeEvent" msprop:Generator_TableVarName="tablemensalistaVeiculo" msprop:Generator_TablePropName="mensalistaVeiculo" msprop:Generator_RowDeletingName="mensalistaVeiculoRowDeleting" msprop:Generator_RowChangingName="mensalistaVeiculoRowChanging" msprop:Generator_RowDeletedName="mensalistaVeiculoRowDeleted" msprop:Generator_TableClassName="mensalistaVeiculoDataTable" msprop:Generator_RowChangedName="mensalistaVeiculoRowChanged" msprop:Generator_RowEvHandlerName="mensalistaVeiculoRowChangeEventHandler" msprop:Generator_RowClassName="mensalistaVeiculoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnPropNameInTable="PlacaColumn" msprop:Generator_UserColumnName="Placa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Marca" msprop:Generator_ColumnVarNameInTable="columnMarca" msprop:Generator_ColumnPropNameInRow="Marca" msprop:Generator_ColumnPropNameInTable="MarcaColumn" msprop:Generator_UserColumnName="Marca" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Modelo" msprop:Generator_ColumnVarNameInTable="columnModelo" msprop:Generator_ColumnPropNameInRow="Modelo" msprop:Generator_ColumnPropNameInTable="ModeloColumn" msprop:Generator_UserColumnName="Modelo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoVeiculo" msprop:Generator_ColumnVarNameInTable="columnTipoVeiculo" msprop:Generator_ColumnPropNameInRow="TipoVeiculo" msprop:Generator_ColumnPropNameInTable="TipoVeiculoColumn" msprop:Generator_UserColumnName="TipoVeiculo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PorteVeiculo" msprop:Generator_ColumnVarNameInTable="columnPorteVeiculo" msprop:Generator_ColumnPropNameInRow="PorteVeiculo" msprop:Generator_ColumnPropNameInTable="PorteVeiculoColumn" msprop:Generator_UserColumnName="PorteVeiculo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="mensalistaFranquia" msprop:Generator_UserTableName="mensalistaFranquia" msprop:Generator_RowEvArgName="mensalistaFranquiaRowChangeEvent" msprop:Generator_TableVarName="tablemensalistaFranquia" msprop:Generator_TablePropName="mensalistaFranquia" msprop:Generator_RowDeletingName="mensalistaFranquiaRowDeleting" msprop:Generator_RowChangingName="mensalistaFranquiaRowChanging" msprop:Generator_RowDeletedName="mensalistaFranquiaRowDeleted" msprop:Generator_TableClassName="mensalistaFranquiaDataTable" msprop:Generator_RowChangedName="mensalistaFranquiaRowChanged" msprop:Generator_RowEvHandlerName="mensalistaFranquiaRowChangeEventHandler" msprop:Generator_RowClassName="mensalistaFranquiaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DataIni" msprop:Generator_ColumnVarNameInTable="columnDataIni" msprop:Generator_ColumnPropNameInRow="DataIni" msprop:Generator_ColumnPropNameInTable="DataIniColumn" msprop:Generator_UserColumnName="DataIni" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataFim" msprop:Generator_ColumnVarNameInTable="columnDataFim" msprop:Generator_ColumnPropNameInRow="DataFim" msprop:Generator_ColumnPropNameInTable="DataFimColumn" msprop:Generator_UserColumnName="DataFim" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="mensalistaPagamento" msprop:Generator_UserTableName="mensalistaPagamento" msprop:Generator_RowEvArgName="mensalistaPagamentoRowChangeEvent" msprop:Generator_TableVarName="tablemensalistaPagamento" msprop:Generator_TablePropName="mensalistaPagamento" msprop:Generator_RowDeletingName="mensalistaPagamentoRowDeleting" msprop:Generator_RowChangingName="mensalistaPagamentoRowChanging" msprop:Generator_RowDeletedName="mensalistaPagamentoRowDeleted" msprop:Generator_TableClassName="mensalistaPagamentoDataTable" msprop:Generator_RowChangedName="mensalistaPagamentoRowChanged" msprop:Generator_RowEvHandlerName="mensalistaPagamentoRowChangeEventHandler" msprop:Generator_RowClassName="mensalistaPagamentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Recebimento" msprop:Generator_ColumnVarNameInTable="columnRecebimento" msprop:Generator_ColumnPropNameInRow="Recebimento" msprop:Generator_ColumnPropNameInTable="RecebimentoColumn" msprop:Generator_UserColumnName="Recebimento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" msprop:Generator_UserColumnName="DtVencimento" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DtPagamento" msprop:Generator_ColumnVarNameInTable="columnDtPagamento" msprop:Generator_ColumnPropNameInRow="DtPagamento" msprop:Generator_ColumnPropNameInTable="DtPagamentoColumn" msprop:Generator_UserColumnName="DtPagamento" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FormaPagamento" msprop:Generator_ColumnVarNameInTable="columnFormaPagamento" msprop:Generator_ColumnPropNameInRow="FormaPagamento" msprop:Generator_ColumnPropNameInTable="FormaPagamentoColumn" msprop:Generator_UserColumnName="FormaPagamento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValorRec" msprop:Generator_ColumnVarNameInTable="columnValorRec" msprop:Generator_ColumnPropNameInRow="ValorRec" msprop:Generator_ColumnPropNameInTable="ValorRecColumn" msprop:Generator_UserColumnName="ValorRec" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="mensalistaPagementoAberto" msprop:Generator_UserTableName="mensalistaPagementoAberto" msprop:Generator_RowEvArgName="mensalistaPagementoAbertoRowChangeEvent" msprop:Generator_TableVarName="tablemensalistaPagementoAberto" msprop:Generator_TablePropName="mensalistaPagementoAberto" msprop:Generator_RowDeletingName="mensalistaPagementoAbertoRowDeleting" msprop:Generator_RowChangingName="mensalistaPagementoAbertoRowChanging" msprop:Generator_RowDeletedName="mensalistaPagementoAbertoRowDeleted" msprop:Generator_TableClassName="mensalistaPagementoAbertoDataTable" msprop:Generator_RowChangedName="mensalistaPagementoAbertoRowChanged" msprop:Generator_RowEvHandlerName="mensalistaPagementoAbertoRowChangeEventHandler" msprop:Generator_RowClassName="mensalistaPagementoAbertoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Recebimento" msprop:Generator_ColumnVarNameInTable="columnRecebimento" msprop:Generator_ColumnPropNameInRow="Recebimento" msprop:Generator_ColumnPropNameInTable="RecebimentoColumn" msprop:Generator_UserColumnName="Recebimento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" msprop:Generator_UserColumnName="DtVencimento" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="mensalista" msprop:Generator_UserTableName="mensalista" msprop:Generator_RowEvArgName="mensalistaRowChangeEvent" msprop:Generator_TableVarName="tablemensalista" msprop:Generator_TablePropName="mensalista" msprop:Generator_RowDeletingName="mensalistaRowDeleting" msprop:Generator_RowChangingName="mensalistaRowChanging" msprop:Generator_RowDeletedName="mensalistaRowDeleted" msprop:Generator_TableClassName="mensalistaDataTable" msprop:Generator_RowChangedName="mensalistaRowChanged" msprop:Generator_RowEvHandlerName="mensalistaRowChangeEventHandler" msprop:Generator_RowClassName="mensalistaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Endereco" msprop:Generator_ColumnVarNameInTable="columnEndereco" msprop:Generator_ColumnPropNameInRow="Endereco" msprop:Generator_ColumnPropNameInTable="EnderecoColumn" msprop:Generator_UserColumnName="Endereco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="75" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EnderecoNumero" msprop:Generator_ColumnVarNameInTable="columnEnderecoNumero" msprop:Generator_ColumnPropNameInRow="EnderecoNumero" msprop:Generator_ColumnPropNameInTable="EnderecoNumeroColumn" msprop:Generator_UserColumnName="EnderecoNumero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Complemento" msprop:Generator_ColumnVarNameInTable="columnComplemento" msprop:Generator_ColumnPropNameInRow="Complemento" msprop:Generator_ColumnPropNameInTable="ComplementoColumn" msprop:Generator_UserColumnName="Complemento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnPropNameInTable="BairroColumn" msprop:Generator_UserColumnName="Bairro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn" msprop:Generator_UserColumnName="Cidade" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UF" msprop:Generator_ColumnVarNameInTable="columnUF" msprop:Generator_ColumnPropNameInRow="UF" msprop:Generator_ColumnPropNameInTable="UFColumn" msprop:Generator_UserColumnName="UF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone1" msprop:Generator_ColumnVarNameInTable="columnTelefone1" msprop:Generator_ColumnPropNameInRow="Telefone1" msprop:Generator_ColumnPropNameInTable="Telefone1Column" msprop:Generator_UserColumnName="Telefone1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone2" msprop:Generator_ColumnVarNameInTable="columnTelefone2" msprop:Generator_ColumnPropNameInRow="Telefone2" msprop:Generator_ColumnPropNameInTable="Telefone2Column" msprop:Generator_UserColumnName="Telefone2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone3" msprop:Generator_ColumnVarNameInTable="columnTelefone3" msprop:Generator_ColumnPropNameInRow="Telefone3" msprop:Generator_ColumnPropNameInTable="Telefone3Column" msprop:Generator_UserColumnName="Telefone3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contato" msprop:Generator_ColumnVarNameInTable="columnContato" msprop:Generator_ColumnPropNameInRow="Contato" msprop:Generator_ColumnPropNameInTable="ContatoColumn" msprop:Generator_UserColumnName="Contato" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Responsavel" msprop:Generator_ColumnVarNameInTable="columnResponsavel" msprop:Generator_ColumnPropNameInRow="Responsavel" msprop:Generator_ColumnPropNameInTable="ResponsavelColumn" msprop:Generator_UserColumnName="Responsavel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ativo" msprop:Generator_ColumnVarNameInTable="columnAtivo" msprop:Generator_ColumnPropNameInRow="Ativo" msprop:Generator_ColumnPropNameInTable="AtivoColumn" msprop:Generator_UserColumnName="Ativo" type="xs:boolean" minOccurs="0" />
              <xs:element name="CPF" msprop:Generator_ColumnVarNameInTable="columnCPF" msprop:Generator_ColumnPropNameInRow="CPF" msprop:Generator_ColumnPropNameInTable="CPFColumn" msprop:Generator_UserColumnName="CPF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CNPJ" msprop:Generator_ColumnVarNameInTable="columnCNPJ" msprop:Generator_ColumnPropNameInRow="CNPJ" msprop:Generator_ColumnPropNameInTable="CNPJColumn" msprop:Generator_UserColumnName="CNPJ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IE" msprop:Generator_ColumnVarNameInTable="columnIE" msprop:Generator_ColumnPropNameInRow="IE" msprop:Generator_ColumnPropNameInTable="IEColumn" msprop:Generator_UserColumnName="IE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IM" msprop:Generator_ColumnVarNameInTable="columnIM" msprop:Generator_ColumnPropNameInRow="IM" msprop:Generator_ColumnPropNameInTable="IMColumn" msprop:Generator_UserColumnName="IM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pais" msprop:Generator_ColumnVarNameInTable="columnPais" msprop:Generator_ColumnPropNameInRow="Pais" msprop:Generator_ColumnPropNameInTable="PaisColumn" msprop:Generator_UserColumnName="Pais" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SMS" msprop:Generator_ColumnVarNameInTable="columnSMS" msprop:Generator_ColumnPropNameInRow="SMS" msprop:Generator_ColumnPropNameInTable="SMSColumn" msprop:Generator_UserColumnName="SMS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdCliente" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdCliente" msprop:Generator_ColumnPropNameInRow="IdCliente" msprop:Generator_ColumnPropNameInTable="IdClienteColumn" msprop:Generator_UserColumnName="IdCliente" type="xs:int" />
              <xs:element name="QtdVagas" msprop:Generator_ColumnVarNameInTable="columnQtdVagas" msprop:Generator_ColumnPropNameInRow="QtdVagas" msprop:Generator_ColumnPropNameInTable="QtdVagasColumn" msprop:Generator_UserColumnName="QtdVagas" type="xs:int" minOccurs="0" />
              <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" type="xs:boolean" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="TabelaMensal" msprop:Generator_ColumnVarNameInTable="columnTabelaMensal" msprop:Generator_ColumnPropNameInRow="TabelaMensal" msprop:Generator_ColumnPropNameInTable="TabelaMensalColumn" msprop:Generator_UserColumnName="TabelaMensal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="placaMovimentacao" msprop:Generator_UserTableName="placaMovimentacao" msprop:Generator_RowEvArgName="placaMovimentacaoRowChangeEvent" msprop:Generator_TableVarName="tableplacaMovimentacao" msprop:Generator_TablePropName="placaMovimentacao" msprop:Generator_RowDeletingName="placaMovimentacaoRowDeleting" msprop:Generator_RowChangingName="placaMovimentacaoRowChanging" msprop:Generator_RowDeletedName="placaMovimentacaoRowDeleted" msprop:Generator_TableClassName="placaMovimentacaoDataTable" msprop:Generator_RowChangedName="placaMovimentacaoRowChanged" msprop:Generator_RowEvHandlerName="placaMovimentacaoRowChangeEventHandler" msprop:Generator_RowClassName="placaMovimentacaoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnPropNameInTable="PlacaColumn" msprop:Generator_UserColumnName="Placa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Entrada" msprop:Generator_ColumnVarNameInTable="columnEntrada" msprop:Generator_ColumnPropNameInRow="Entrada" msprop:Generator_ColumnPropNameInTable="EntradaColumn" msprop:Generator_UserColumnName="Entrada" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Saida" msprop:Generator_ColumnVarNameInTable="columnSaida" msprop:Generator_ColumnPropNameInRow="Saida" msprop:Generator_ColumnPropNameInTable="SaidaColumn" msprop:Generator_UserColumnName="Saida" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="Especie" msprop:Generator_ColumnVarNameInTable="columnEspecie" msprop:Generator_ColumnPropNameInRow="Especie" msprop:Generator_ColumnPropNameInTable="EspecieColumn" msprop:Generator_UserColumnName="Especie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="placaVeiculo" msprop:Generator_UserTableName="placaVeiculo" msprop:Generator_RowEvArgName="placaVeiculoRowChangeEvent" msprop:Generator_TableVarName="tableplacaVeiculo" msprop:Generator_TablePropName="placaVeiculo" msprop:Generator_RowDeletingName="placaVeiculoRowDeleting" msprop:Generator_RowChangingName="placaVeiculoRowChanging" msprop:Generator_RowDeletedName="placaVeiculoRowDeleted" msprop:Generator_TableClassName="placaVeiculoDataTable" msprop:Generator_RowChangedName="placaVeiculoRowChanged" msprop:Generator_RowEvHandlerName="placaVeiculoRowChangeEventHandler" msprop:Generator_RowClassName="placaVeiculoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnPropNameInTable="PlacaColumn" msprop:Generator_UserColumnName="Placa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Marca" msprop:Generator_ColumnVarNameInTable="columnMarca" msprop:Generator_ColumnPropNameInRow="Marca" msprop:Generator_ColumnPropNameInTable="MarcaColumn" msprop:Generator_UserColumnName="Marca" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Modelo" msprop:Generator_ColumnVarNameInTable="columnModelo" msprop:Generator_ColumnPropNameInRow="Modelo" msprop:Generator_ColumnPropNameInTable="ModeloColumn" msprop:Generator_UserColumnName="Modelo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PorteVeiculo" msprop:Generator_ColumnVarNameInTable="columnPorteVeiculo" msprop:Generator_ColumnPropNameInRow="PorteVeiculo" msprop:Generator_ColumnPropNameInTable="PorteVeiculoColumn" msprop:Generator_UserColumnName="PorteVeiculo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoVeiculo" msprop:Generator_ColumnVarNameInTable="columnTipoVeiculo" msprop:Generator_ColumnPropNameInRow="TipoVeiculo" msprop:Generator_ColumnPropNameInTable="TipoVeiculoColumn" msprop:Generator_UserColumnName="TipoVeiculo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="eMensal" msprop:Generator_UserTableName="eMensal" msprop:Generator_RowEvArgName="eMensalRowChangeEvent" msprop:Generator_TableVarName="tableeMensal" msprop:Generator_TablePropName="eMensal" msprop:Generator_RowDeletingName="eMensalRowDeleting" msprop:Generator_RowChangingName="eMensalRowChanging" msprop:Generator_RowDeletedName="eMensalRowDeleted" msprop:Generator_TableClassName="eMensalDataTable" msprop:Generator_RowChangedName="eMensalRowChanged" msprop:Generator_RowEvHandlerName="eMensalRowChangeEventHandler" msprop:Generator_RowClassName="eMensalRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="valor" msprop:Generator_ColumnVarNameInTable="columnvalor" msprop:Generator_ColumnPropNameInRow="valor" msprop:Generator_ColumnPropNameInTable="valorColumn" msprop:Generator_UserColumnName="valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="Especie" msprop:Generator_ColumnVarNameInTable="columnEspecie" msprop:Generator_ColumnPropNameInRow="Especie" msprop:Generator_ColumnPropNameInTable="EspecieColumn" msprop:Generator_UserColumnName="Especie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quantidade" msprop:Generator_ColumnVarNameInTable="columnquantidade" msprop:Generator_ColumnPropNameInRow="quantidade" msprop:Generator_ColumnPropNameInTable="quantidadeColumn" msprop:Generator_UserColumnName="quantidade" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="eMensalAnalitico" msprop:Generator_UserTableName="eMensalAnalitico" msprop:Generator_RowEvArgName="eMensalAnaliticoRowChangeEvent" msprop:Generator_TableVarName="tableeMensalAnalitico" msprop:Generator_TablePropName="eMensalAnalitico" msprop:Generator_RowDeletingName="eMensalAnaliticoRowDeleting" msprop:Generator_RowChangingName="eMensalAnaliticoRowChanging" msprop:Generator_RowDeletedName="eMensalAnaliticoRowDeleted" msprop:Generator_TableClassName="eMensalAnaliticoDataTable" msprop:Generator_RowChangedName="eMensalAnaliticoRowChanged" msprop:Generator_RowEvHandlerName="eMensalAnaliticoRowChangeEventHandler" msprop:Generator_RowClassName="eMensalAnaliticoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="valor" msprop:Generator_ColumnVarNameInTable="columnvalor" msprop:Generator_ColumnPropNameInRow="valor" msprop:Generator_ColumnPropNameInTable="valorColumn" msprop:Generator_UserColumnName="valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="Especie" msprop:Generator_ColumnVarNameInTable="columnEspecie" msprop:Generator_ColumnPropNameInRow="Especie" msprop:Generator_ColumnPropNameInTable="EspecieColumn" msprop:Generator_UserColumnName="Especie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quantidade" msprop:Generator_ColumnVarNameInTable="columnquantidade" msprop:Generator_ColumnPropNameInRow="quantidade" msprop:Generator_ColumnPropNameInTable="quantidadeColumn" msprop:Generator_UserColumnName="quantidade" type="xs:long" />
              <xs:element name="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnPropNameInTable="DiaColumn" msprop:Generator_UserColumnName="Dia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="eDia" msprop:Generator_TableClassName="eDiaDataTable" msprop:Generator_RowEvArgName="eDiaRowChangeEvent" msprop:Generator_TableVarName="tableeDia" msprop:Generator_TablePropName="eDia" msprop:Generator_RowDeletingName="eDiaRowDeleting" msprop:Generator_UserTableName="eDia" msprop:Generator_RowChangingName="eDiaRowChanging" msprop:Generator_RowDeletedName="eDiaRowDeleted" msprop:Generator_RowChangedName="eDiaRowChanged" msprop:Generator_RowEvHandlerName="eDiaRowChangeEventHandler" msprop:Generator_RowClassName="eDiaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnPropNameInTable="DiaColumn" msprop:Generator_UserColumnName="Dia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Qtd" msprop:Generator_ColumnVarNameInTable="columnQtd" msprop:Generator_ColumnPropNameInRow="Qtd" msprop:Generator_ColumnPropNameInTable="QtdColumn" msprop:Generator_UserColumnName="Qtd" type="xs:long" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="eMes" msprop:Generator_TableClassName="eMesDataTable" msprop:Generator_RowEvArgName="eMesRowChangeEvent" msprop:Generator_TableVarName="tableeMes" msprop:Generator_TablePropName="eMes" msprop:Generator_RowDeletingName="eMesRowDeleting" msprop:Generator_UserTableName="eMes" msprop:Generator_RowChangingName="eMesRowChanging" msprop:Generator_RowDeletedName="eMesRowDeleted" msprop:Generator_RowChangedName="eMesRowChanged" msprop:Generator_RowEvHandlerName="eMesRowChangeEventHandler" msprop:Generator_RowClassName="eMesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Qtd" msprop:Generator_ColumnVarNameInTable="columnQtd" msprop:Generator_ColumnPropNameInRow="Qtd" msprop:Generator_ColumnPropNameInTable="QtdColumn" msprop:Generator_UserColumnName="Qtd" type="xs:long" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnPropNameInTable="MesColumn" msprop:Generator_UserColumnName="Mes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:mensalistaVeiculo" />
      <xs:field xpath="mstns:Placa" />
    </xs:unique>
    <xs:unique name="mensalista_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:mensalista" />
      <xs:field xpath="mstns:IdCliente" />
    </xs:unique>
    <xs:unique name="placaVeiculo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:placaVeiculo" />
      <xs:field xpath="mstns:Placa" />
    </xs:unique>
  </xs:element>
</xs:schema>